﻿Imports System.Data.OleDb
Public Class detail
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub btn_AddComment_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btn_AddComment.Click
        Dim conn As OleDbConnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("MotorcyclesConn").ConnectionString)

        Dim sql = "INSERT INTO Comments (Author,Subject,Message,MotorcyclesID) VALUES (@f1,@f2,@f3,@f4)"

        Dim cmd = New OleDbCommand(sql, conn)

        conn.Open()

        cmd.Parameters.AddWithValue("@f1", tb_Name.Text)
        cmd.Parameters.AddWithValue("@f2", tb_Title.Text)
        cmd.Parameters.AddWithValue("@f3", tb_Comment.Text)
        cmd.Parameters.AddWithValue("@f4", Request.Params("ID"))

        cmd.ExecuteNonQuery()

        conn.Close()

        Response.Redirect("detail.aspx?ID=" & Request.Params("ID"))

    End Sub
End Class